<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateHouseAuditTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('house_audit', function (Blueprint $table) {
            $table->increments('id');
            $table->string('house_logo')->default('')->comment('房源图片');
            $table->string('house_name')->default('')->comment('小区名称');
            $table->string('house_type')->default('')->comment('房源类型');
            $table->string('house_area')->default('')->comment('区域');
            $table->string('house_molding')->default('')->comment('房源户型');
            $table->string('house_floor')->default('')->comment('楼层');
            $table->string('house_acreage')->default('')->comment('房源面积');
            $table->string('house_price')->default('')->comment('售价');
            $table->string('house_title')->default('')->comment('房源标题');
            $table->string('house_text')->default('')->comment('简介');
            $table->string('audit_status')->default('')->comment('审核状态:0正在审核，1审核通过，2拒绝通过');
            $table->string('square_price')->default('')->comment('平方价格');
            $table->string('house_way')->default('')->comment('入住方式:1买房，2租房');
            $table->string('status')->default('')->comment('展示状态:0关闭1正常');
            $table->string('house_address')->default('')->comment('房源地址');
            $table->string('house_broker')->default('')->comment('经纪人');
            $table->timestamps();
            $table->softDeletes();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('house_audit');
    }
}
